Diagram WaitingList

Defincja diagramu WaitingList

Name

WaitingList

Code

WaitingList

Comment

Waiting list submodel


Lista tabel diagramu

Name

Code

BeneficiaryCategory

BeneficiaryCategory

BeneficiaryCategoryText

BeneficiaryCategoryText

ContractOrgUnit

ContractOrgUnit

DictionaryValue

DictionaryValue

Episode

Episode

Event

Event

ExternalDoctor

ExternalDoctor

ExternalOrgUnit

ExternalOrgUnit

FieldDefinition

FieldDefinition

ICD

ICD

Insurer

Insurer

LWaitingListContrOrgUnit

LWaitingListContrOrgUnit

LWaitingListItemBodyArea

LWaitingListItemBodyArea

LWaitingListItemChange

LWaitingListItemChange

LWaitingListItemIdentifier

LWaitingListItemIdentifier

LWaitingListItemStatus

LWaitingListItemStatus

LWaitingListOrgUnit

LWaitingListOrgUnit

Patient

Patient

PerfService

PerfService

Person

Person

Personnel

Personnel

SysFct

SysFct

UserDefinition

UserDefinition

Visit

Visit

VisitCancelReason

VisitCancelReason

WaitingList

WaitingList

WaitingListCancelReason

WaitingListCancelReason

WaitingListCancelReasonEx

WaitingListCancelReasonEx

WaitingListCancelReasonExText

WaitingListCancelReasonExText

WaitingListCancelReasonText

WaitingListCancelReasonText

WaitingListCategory

WaitingListCategory

WaitingListCategoryText

WaitingListCategoryText

WaitingListItem

WaitingListItem

WaitingListItemDetails

WaitingListItemDetails

WaitingListItemStatus

WaitingListItemStatus

WaitingListItemStatusText

WaitingListItemStatusText

WaitingListNfzProcCodes

WaitingListNfzProcCodes

WaitingListNfzStatCodes

WaitingListNfzStatCodes

WaitingListPerfOrgUnit

WaitingListPerfOrgUnit

WaitingListReferralStatus

WaitingListReferralStatus

WaitingListReferralStatusText

WaitingListReferralStatusText

WaitingListStatData

WaitingListStatData

WaitingListWarnings

WaitingListWarnings

WLPerfOUType

WLPerfOUType

WLPerfOUTypeText

WLPerfOUTypeText


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_343

R_343

Patient

Episode

PersonID

 

 

R_394

R_394

Patient

Visit

PersonID

 

 

R_1619

R_1619

ICD

LWaitingListContrOrgUnit

ICDID

 

 

R_1620

R_1620

WaitingList

LWaitingListContrOrgUnit

WaitingListID

 

 

R_1621

R_1621

ContractOrgUnit

LWaitingListContrOrgUnit

ContractOrgUnitID

 

 

R_1622

R_1622

WaitingListCategory

WaitingListCategoryText

WaitingListCategoryID

 

 

R_1623

R_1623

WaitingList

WaitingListItem

WaitingListID

 

 

R_1624

R_1624

Patient

WaitingListItem

PersonID

 

 

R_1625

R_1625

ExternalDoctor

WaitingListItem

ExternalDoctorID

 

 

R_1627

R_1627

Episode

WaitingListItem

EpisodeID

 

 

R_1628

R_1628

Visit

WaitingListItem

VisitID

 

 

R_1629

R_1629

PerfService

WaitingListItem

PerfServiceID

 

 

R_1630

R_1630

WaitingListCategory

WaitingListItem

WaitingListCategoryID

 

 

R_1631

R_1631

Personnel

WaitingListItem

InsertingDoctor

 

 

R_1632

R_1632

WaitingListItemStatus

WaitingListItemStatusText

WaitingListItemStatusID

 

 

R_1633

R_1633

WaitingListCancelReason

WaitingListCancelReasonText

WaitingListCancelReasonID

 

 

R_1634

R_1634

WaitingListCancelReason

LWaitingListItemStatus

WaitingListCancelReasonID

 

 

R_1635

R_1635

WaitingListItemStatus

LWaitingListItemStatus

WaitingListItemStatusID

 

 

R_1636

R_1636

WaitingListItem

LWaitingListItemStatus

WaitingListItemID

 

 

R_1638

R_1638

WaitingListItem

LWaitingListItemIdentifier

WaitingListItemID

 

 

R_1665

R_1665

ICD

WaitingListItem

ICDID

 

 

R_1953

R_1953

Person

WaitingListItemDetails

OperatorDoctor

 

 

R_8060

R_8060

ExternalOrgUnit

WaitingListItem

ExternalOrgUnitID

 

 

R_8202

R_8202

Person

WaitingListItem

ConfirmingPerson

 

 

R_8203

R_8203

Person

WaitingListItem

QualifyingPerson

 

 

R_8737

R_8737

WaitingListCancelReasonEx

WaitingListCancelReasonExText

WaitingListCancelReasonExID

 

 

R_8738

R_8738

WaitingListCancelReasonEx

LWaitingListItemStatus

WaitingListCancelReasonExID

 

 

R_8783

R_8783

ContractOrgUnit

WaitingListNfzStatCodes

ContractOrgUnitID

 

 

R_9007

R_9007

WaitingListItem

WaitingListItem

Wai_WaitingListItemID

 

 

R_9008

R_9008

ICD

WaitingListItem

ICDIDByEnteringPerson

 

 

R_9009

R_9009

WaitingList

WaitingListStatData

WaitingListID

 

 

R_9010

R_9010

WaitingListCategory

WaitingListStatData

WaitingListCategoryID

 

 

R_9020

R_9020

WaitingList

WaitingListWarnings

WaitingListID

 

 

R_9021

R_9021

WaitingListItem

WaitingListWarnings

WaitingListItemID

 

 

R_9022

R_9022

UserDefinition

WaitingListWarnings

InsertingPerson

 

 

R_9076

R_9076

WaitingList

LWaitingListOrgUnit

WaitingListID

 

 

R_9085

R_9085

WaitingListItem

WaitingListItemDetails

WaitingListItemID

 

 

R_9119

R_9119

WaitingListCancelReason

VisitCancelReason

WaitingListCancelReasonID

 

 

R_9143

R_9143

WaitingList

WaitingListPerfOrgUnit

WaitingListID

 

 

R_9183

R_9183

WLPerfOUType

WLPerfOUTypeText

WLPerfOUTypeID

 

 

R_9184

R_9184

WLPerfOUType

WaitingListPerfOrgUnit

WLPerfOUTypeID

 

 

R_9186

R_9186

Person

WaitingListItemDetails

ExpectedDTChangePerson

 

 

R_9359

R_9359

Event

WaitingListItemDetails

OriginalEventID

 

 

R_9473

R_9473

WaitingListReferralStatus

WaitingListReferralStatusText

WaitingListReferralStatusID

 

 

R_9474

R_9474

WaitingListReferralStatus

WaitingListItemDetails

WaitingListReferralStatusID

 

 

R_9480

R_9480

DictionaryValue

WaitingListItemDetails

OncologicStageID

 

 

R_9783

R_9783

SysFct

WaitingListItem

InsertingFunctionID

 

 

R_9784

R_9784

SysFct

WaitingListItem

LastModifiedFunctionID

 

 

R_9785

R_9785

SysFct

LWaitingListItemStatus

LastModifiedFunctionID

 

 

R_10485

R_10485

BeneficiaryCategory

BeneficiaryCategoryText

BeneficiaryCategoryId

 

 


2